package com.qf.mapper;

import com.qf.entity.Emp;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.sql.SQLException;
import java.util.List;

/**
 * User: key
 * ClassName:EmpDao
 * Date: 2023/5/25
 * Time: 16:35
 * description:
 */
public interface EmpMapper {
    public List<Emp> selectAll() throws SQLException;

    public Emp select(Emp emp) throws SQLException;
    public Emp select(Integer eno) throws SQLException;
    public Emp selectBy(String username,String password) throws SQLException;

    public Integer insert(Emp emp) throws SQLException;

    public Integer update(Emp emp) throws SQLException;

    public Integer delete(Integer eno) throws SQLException;

    public Integer getTotal();
    public List<Emp> listEmp(@Param("start") Integer start,@Param("pageSize") Integer pageSize);
//
//    List<Emp> findByPage(Integer start, Integer size);

//    public List<Emp> pagination(Integer start,Integer end);

}
